	
/****** Object:  Stored Procedure OfficesUpdate    Script Date: Friday, March 07, 2008 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spOfficesUpdate]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [spOfficesUpdate]
GO

	
	

	
/******************************************************************************
**		File: 
**		Name: spOfficesUpdate
**		Desc: 
**
**		Return values:
** 
**		Called by:   
**              
**		Parameters:
**		Input							Output
**     ----------							-----------
**
**		Auth: CodeSmith
**		Date: 3/7/2008 11:26:45 AM
*******************************************************************************
**		Change History
*******************************************************************************
**		Date:		Author:				Description:
**		--------		--------				-------------------------------------------
**    
*******************************************************************************/
CREATE PROCEDURE spOfficesUpdate
	@OfficeID int, 
	@OfficeName nvarchar(100), 
	@OfficeCode varchar(10), 
	@NotifyEmailEnable bit, 
	@SortOrder int 
AS

UPDATE [Offices] SET
	[OfficeName] = @OfficeName,
	[OfficeCode] = @OfficeCode,
	[NotifyEmailEnable] = @NotifyEmailEnable,
	[SortOrder] = @SortOrder
WHERE
	[OfficeID] = @OfficeID

GO
